Original: http://my.oschina.net/leejun2005/blog/343353Catalogue [-]
1. Problem: MySQL encountered some Chinese insert exception
2, Reason: This UTF8 non-UTF8
3. Solutions
3.1 Upgrading the MySQL version and upgrading the UTF8
Introduction: This is a detailed page of MySQL database encoding problem 3 (modifying the database, table, and field encoding to utf8). It introduces the related knowledge, skills, and experience of PHP, and some PHP source code.
Class = 'pingjiaf'
1. Problem: MySQL encountered some Chinese Insert Exception recently, some students have feedback on such a problem: The above statement will hang when the load is in the script, the Web front end, the command line operation is either thrown
Modify database MySQL character encoding to UTF8The MySQL database is an open-source database that is widely used. The following is a procedure for modifying the character encoding of a MySQL database. Step 1: View the current character encoding
Personally, we recommend that you use utf8 as much as possible for the database character set (the HTML page corresponds to UTF-8) so that your data can be migrated smoothly.
Personally, we recommend that you use utf8 as much as possible for the
Because the UTF8 character set is the character set that is best suited to implement conversions between many different character sets, although you may not be able to view the contents of the database correctly on command-line tools, I strongly
Because the utf8 character set is currently the most suitable character set for conversion between different character sets, although you may not be able to correctly view the content in the database on the command line tool, I still strongly
Town Yard text:The Confucian School of the practical and practical, line Buddhism Purdue sentient beings, the monastic Kangsheng fidelity, understanding of the easy to change the image. To science and technology to shine a good law, the achievement
Comprehensive understanding of the differences between utf8 and utf8mb4 in mysql, utf8utf8mb4
I. Introduction
MySQL added the utf8mb4 encoding after 5.5.3. mb4 is the meaning of most bytes 4, which is specially used to be compatible with four-byte
First, Introduction
MySQL added this utf8mb4 code after 5.5.3, MB4 is most bytes 4, and is designed to be compatible with four-byte Unicode. Fortunately, UTF8MB4 is a superset of UTF8, and there is no need for other conversions except to change the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.